Write GetDataCell expressions in the cube view row or column. It will calculate at runtime. The expressions require a reference to specific dimension members to return a data point. Use GetDataCell expressions if you are running calculations on members that are not currently in the cube view or if the expression is easy to create and maintain. GetDataCell expressions are simpler versions of dynamic calculations.
NOTE: Use one of the other calculation types if you are querying multiple member combinations.
Samples Tab
In the Member Filter Builder, use the Samples tab to create simple GetDataCell expressions in your cube view.
In Member Filter Builder, click Samples.
There is a list of preexisting GetDataCell expressions you can use. For detailed information, see the following table.
| Function Name | Description | Example |
|---|---|---|
| Variance | Calculates the difference as a ratio between two scenarios using the Variance function. | GetDataCell(Variance(S#Scenario1, S#Scenario2)):Name(Variance) |
| Variance% | Calculates the difference as a percentage between two scenarios using the VariancePercent function. | GetDataCell(VariancePercent (S#Scenario1, S#Scenario2)):Name(Var%) |
| Better or Worse | Calculates the difference between two scenarios while considering account types using the BWDiff function. | GetDataCell(BWDiff(S#Scenario1, S#Scenario2)):Name(BW Diff) |
| Better or Worse% | Calculates the difference as a percentage between two scenarios while considering account types using the BWPercent function. | GetDataCell(BWPercent(S#Scenario1, S#Scenario2)):Name(BW%) |
| Ratio | Calculates the ratio between two scenarios using the Divide function. | GetDataCell(Divide(S#Scenario1, S#Scenario2)):Name(Ratio) |
| Difference | Calculates the difference between scenarios using the Subtraction function. |
GetDataCell(S#Scenario1-S#Scenario2): Name(Difference) |
| Sum | Calculates the sum of two scenarios using the Addition function. | GetDataCell(S#Scenario1+ S#Scenario2: Name(Total) |
| Custom Function (condensed syntax) | Calls a Finance business rule using the BR# function.
|
GetDataCell(BR#[MyBusinessRuleName, MyFunctionName]): Name(Custom Function) |
| Custom Function | Calls a Finance business rule using the BR# function.
|
GetDataCell(BR#[BRName=MyBusinessRuleName, FunctionName=MyFunctionName]):Name(Custom Function) |
| Custom Function with Parameters | Calls a Finance business rule using the BR# function.
|
GetDataCell(BR#[BRName=MyBusinessRuleName, FunctionName=MyFunctionName, Name1=Value1, AnotherName=[Another Value]]):Name(Custom Function) |
